Model Table MARKETING CAMPAIGN RESPONSE FACT

This model dimension represents responses created in marketing campaign actions and is based on the IFS Cloud fact FACT_BUSINESS_ACTIVITY. All models that refers to this dimension will have the attributes and hierarchies as described below.

Attributes

Attribute	Description (where applicable)
Activity Sub Type	Activity Sub Types are used to specify the nature of an activity.
CONNECTION_TYPE_DESC	The type of the connection (account or lead) that marketing campaign response is created for.
Campaign Response Connection ID	The ID of the connection (account or lead) that marketing campaign response is created for.
Campaign Response Header Item	The type of activities which are created from the campaign action.
Campaign Response Multiple Choice	The marketing campaign response which is in multiple choice type.
Campaign Response Note	The marketing campaign response which is in note type.
Campaign Response Numeric or Text	The marketing campaign response which is in numeric or text type.
Campaign Response Single Choice	The marketing campaign response which is in single choice type.
Campaign Response Target
Campaign Response Yes or No	The marketing campaign response which is in yes / no type.
Campaign Response Yes or No Description	The marketing campaign response which is in yes / no type.
DIM_ACTION_REPRESENTATIVE_ID	The ID of the relevant marketing campaign action representative.
DIM_CAMPAIGN_ACTIVITY_TYPE	The type of activity which are created from the campaign action.
DIM_CAMPAIGN_TYPE	The type assigned to the relevant marketing campaign.
DIM_CAMP_COMPANY	The company of the relevant marketing campaign.
DIM_CAMP_REPRESENTATIVE_ID	The ID of the relevant marketing campaign representative.
MAIN_REPRESENTATIVE_ID	The ID of the relevant activity representative.

USED BY MODEL(S)

Model Name

Crm

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table	DW Source view (SQL Server)	BI Access View	Referenced Information Source	Recommended Access Type
MARKETING CAMPAIGN RESPONSE FACT	FACT_MKTG_ACTION_RESPONSE_TM	FACT_MKTG_ACTION_RESPONSE_BI	FACT_MKTG_ACTION_RESPONSE	Data Mart